﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Visual/Template/formulario.master" AutoEventWireup="true" CodeFile="Sequence_map.aspx.cs" Inherits="Visual_Procedures_Reports_Reports" %>

<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

    <link href="../../../Styles/interfacemetro/css/modern-responsive.css" rel="stylesheet"
        type="text/css" />
    <link href="../../../Styles/interfacemetro/css/modern.css" rel="stylesheet" type="text/css" />
    <link href="../../../Styles/menustyles.css" rel="stylesheet" type="text/css" />
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="botoes" Runat="Server">
<br /><br /><br /><br /><br /><br /><br />
<div style="margin-left:20px;"><h2>Filter by Organism</h2>
    <div class="input-control select">
    <asp:DropDownList ID="ddOrganism" runat="server" AutoPostBack="True" 
        Width="400px" onselectedindexchanged="ddOrganism_SelectedIndexChanged">
    </asp:DropDownList>
    </div></div>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="header" Runat="Server">
    <h1>Sequence Map Report</h1>
</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="ConteudoDinamico" Runat="Server">
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:vsdbmConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:vsdbmConnectionString.ProviderName %>" 
        
        SelectCommand="SELECT sequence_map.qualifier, sequences.idacession, sequences.definition, reference_features.description, reference_features.name, reference_features.featurekey, sequence_map.id, sequences.idorganism, organisms.name AS Expr1 FROM sequences INNER JOIN sequence_map ON sequences.id = sequence_map.idsequence INNER JOIN reference_features ON sequence_map.idfeature = reference_features.id INNER JOIN organisms ON sequences.idorganism = organisms.id WHERE (sequences.idorganism = 0)">
    </asp:SqlDataSource>
    
    <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" 
        Font-Size="8pt" InteractiveDeviceInfos="(Collection)" 
        WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="757px" 
        onreportrefresh="ReportViewer1_ReportRefresh">
        <LocalReport ReportPath="App_Code\reports\Sequence_map_report.rdlc">
            <DataSources>
                <rsweb:ReportDataSource DataSourceId="SqlDataSource1" Name="Sequence_map" />
            </DataSources>
        </LocalReport>
    </rsweb:ReportViewer>
    </asp:Content>

